<?php
/**
 * Created by PhpStorm.
 * User: Administrator
 * Date: 2018/9/11
 * Time: 13:43
 */

namespace app\index\controller;


use think\Controller;
use think\Db;

class Test extends Controller
{
    public function index()
    {
        $pass = init_Password('123456');
        $sql = <<<sql
      select * from `sy_shop_admin`
sql;
        $result = Db::query($sql);
        var_dump($result);
    }
}

//create table `sy_shop_admin`(
//`id` int(11) primary key auto_increment,
//             `nickname` char(20) not null default '' comment '用户登陆账号',
//             `password` char(10) not null default '' comment '用户密码',
//             `status` tinyint(1) not null default '0' comment '0 禁用 1 启用',
//             unique key nickname(nickname),
//             key password(password)
//         )engine=innodb charset=utf8mb4;